package com.example.Servlet;

import com.example.Function.DataBaseOp;
import com.google.gson.Gson;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
/**
 * @author echo
 *删除试题
 */
@WebServlet("/DeleteTable")
public class DeleteTable extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String code = req.getParameter("code");
        boolean flag = DataBaseOp.deleteTable(code);
        flag = DataBaseOp.deleteTable(DataBaseOp.getErrorCode(code));
        DataBaseOp.deleteTableName(code);
        DataBaseOp.deleteScore(code);
        DataBaseOp.deleteErrorBookName(code);
        if(flag){
            PrintWriter out = resp.getWriter();
            Gson gson = new Gson();
            out.println(gson.toJson(true));
        }
    }
}
